**This course includes 70+ lectures , 5.5 hours on demand videos, assignment, certificate of completion, LIFETIME access and  a 30 day money  back satisfaction guaranty by udemy ** Learn Excel, PowerPoint and Word 2019 with this tremendous value 3-course bundle. In this Microsoft Office bundle, I make the three essential MS Office programs (Excel, Word and PowerPoint) simple to understand. This bundle includes 3, full-length courses to help you achieve your goals. What's included? MS Excel 2019 MS-Power Point 2019 MS- Word 2019 This bundle includes: 5.5+ hours of video tutorials and will be Updated 70+ individual video lectures and will be updated . Assignments Certificate of completion INSTRUCTOR SUPPORT I understand that students will have questions related to the course and its necessary also for a healthy learning process hence I encourage students to ask their questions related to the course in the Q&A section of the course. Finally, if you are still thinking weather you should enroll or not then I encourage you to watch some of the preview videos and test the waters before you actually enroll in the course and even after enrolling if you feel that this course failed to meet your expectations then you can always ask for a refund within 30 days of purchase.

This program aims to simplify the task of human resource personnel who deal with various types of data, ranging from recruitment, compensation, employee benefit, workforce planning and development programs. It is particularly useful in HR workloads where the HR practitioner needs to perform calculation for salary adjustments and bonus. They will be exposed to "what if" analysis when it comes to a collective agreement on negotiation for bonus, salary and increment proposals for management. Impress your management with the right techniques and skills on how to manage HR data efficiently and to perform the right analysis. Basic Microsoft Windows knowledge is essential with the following pre-requisites: Able to switch between task applications Able to “Create", “Save", “Open" and “Print" spreadsheet Able to use “Undo" or “Redo" function Able to print a spreadsheet with headers and footers added Able to create simple formulas (additional, subtraction, multiplication and division) Able to create simple functions (Sum, Average, Count, Max & Min) Upon completion of this program, participants will: Have a better comprehension on how functions work in Excel Be better able to handle text data Maximize the benefits of filters Be more confident in creating Excel reports Know how to use validation to ensure database integrity Be able to make fast decision with the use of the logical function Learn how to extract relevant data with LOOKUP functions Ensure they obtain data consistency with functions Analyzing Data with Statistical and Math Functions Work with Date Functions Know how to explore various possibilities with “What IF analysis"? Merging Data from Multiple Worksheets Know how to analyzing data with pivot table Identify the differences between custom formatting vs. conditional formatting Gain confidence and learn valuable tips

Unlock the Power Of Microsoft Office and Watch Your Productivity Soar! Microsoft Office is the #1 office software used by +1 billion people worldwide. While many are familiar with Microsoft Office's basic features, few people know about its more advanced capabilities that are designed to save you time, money, and effort. Using step-by-step instructions, Simon Sez IT will quickly guide you through the most popular programs of Microsoft Office 2013: Excel, Word, Outlook, PowerPoint, Access, and Publisher. In addition to mastering the basic features, you'll also learn highly useful advanced capabilities of both Excel and Access. For example, Visual Basic for Applications (VBA) for Excel will show you how to automate repetitive tasks and operations that you perform frequently. This valuable time saving tool and productivity enhancer is a critical tool for anyone who uses Excel frequently. Work inefficiencies add up quickly over time. If you're always 'learning the hard way' when using Microsoft Office 2013, or under-utilizing its full capabilities, then you'll want to invest in these game-changing courses that include lifetime Udemy access. Let your work productivity soar so that you'll have more time for the other things in life that matter! **** Updated November 18, 2015: New Course Added: VBA Intermediate Training: Discover Excel Automation Secrets Contents and Overview In this 10-in-1 course collection, we'll show you important yet often over-looked or unknown features that will help skyrocket your productivity. Microsoft Excel 2013 - Introductory : Spreadsheets for data analysis and formulas for tracking expenses. Microsoft Excel 2013 - Advanced : apply functions, filter data, and create advanced spreadsheet visuals. Microsoft Word 2013: Introductory course on creating documents and brochures, embedding videos, and set up for online collaboration. Microsoft Outlook 2013: Introductory course on email efficiencies to help clear the email clutter and gain control of your inbox. Microsoft PowerPoint 2013: Introductory course on how to create dazzling presentations using animation, audio/video, and collaborative tools with minimal time and effort. Microsoft Access 2013 – Introductory: creating and using databases to become a master of data management, tracking customer information and buying patterns. Microsoft Access 2013 – Advanced : improve your database reporting and information security. Microsoft Publisher 2013: Introductory course on print publications to create professional-looking print material that communicates your organization's strengths and purpose . Microsoft Essential VBA for Excel: learn how to automate repetitive and time-consuming Excel procedures and operations for maximum efficiency. VBA Intermediate Training: Discover Excel Automation Secrets : learn advanced methods for automating tedious Excel jobs, the next step for anyone who has completed basic VBA. This Course Includes 10 individual courses 80 hours of training tutorials Hundreds of educational videos Exercise files A certificate of completion Why Take This Course Most work today happens on a computer – optimize your effort by learning useful software tips and tricks that you'll apply for decades to come! And that will save you valuable time, money and effort. Want to get noticed by your boss or earn the respect of your colleagues? Become the office superstar by becoming the go-to expert on everything related to MS Office 2013! Individual video training for these 6 programs would easily cost thousands of dollars, but this 10-in-1 package is available at one unbelievably low price. Tremendous learning at tremendous savings. What Others Are Saying: "Goes step by step with clear and simple instructions. Takes time in explaining each set before moving to the next." - Judy Weismann "Great online tutorial. Instructor goes slowly and uses great visuals. Easy to understand." - Lisa Armstrong "Instructor's lecture is easy to understand, and he leads at a comfortable pace. His technique of explanation is superior to many other courses I have taken on Udemy thus far." - Erma Trent "I feel as though the teacher is talking to me and he explains everything with great clarity. I wish I knew about this course before, I really feel a lot of respect and admiration for how serious he is in explaining every little thing step by step." - A. Shan

We've all wished for more time to accomplish more during our busy days. What we really need is to learn how to cutback on the time we spend doing routine tasks. For example, the average office worker spends 25% of their work week managing their Outlook inbox. Use the Microsoft Office Applications to their full potential Microsoft Word Styles to create consistent formatting and automate a Table of Contents Create Excel Macros to automate your work Use PowerPoint Master Slides to create eye catching presentations Organize your Outlook inbox with Categories Spend less time doing routine tasks If you've ever thought there must be an easier more efficient way of doing something in Microsoft Office, then this course is for you. During this course I will introduce you to some of the time-saving techniques and tools that each of the Office applications provide. By implementing the tools that I'll walk you through, you will cutback on the time it takes to complete a task, getting back that 25%, and create more dynamic and efficient documents. Lecture Topics You will gain an understanding of how to work with and become more efficient with large sets of data in Excel (Excel Lists/Tables) . Create dynamic reports with Excel PivotTables Get Excel to work for you by automating tasks with Macros Take a quiz at the end of the section to test what you've learned You will learn to streamline your efforts in creating and maintaining Microsoft Word documents. Use Word styles to create consistency throughout the formatting of your documents Take advantage of Microsoft Words built in Tables of Contents tool Take a quiz at the end of the section to test what you've learned You will be immersed into the time-saving techniques of creating efficient PowerPoint presentations. Use Master Slides to eliminate slide by slide formatting Use Custom Shows within the same presentation file Take a quiz at the end of the section to test what you've learned You will break the shackles that tie you to Microsoft Outlook, ultimately getting that time back to be more productive with your day. Use Outlook categories , making searching an organizing a breeze Automate routine Outlook tasks by using "Quick Steps" Take a quiz at the end of the section to test what you've learned Each section has a quiz where you can test your knowledge on the topics discussed throughout the videos. At completion of this course you will be amazed at all the extra time you have during your workday.

**This course includes practice exercises and LIFETIME access** Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT. Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential. We’re here to make sure you aren’t one of those people. In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals. What's included? Excel 2019 What's new in Excel 2019 Creating workbooks Entering text, numbers and working with dates Navigating workbooks Page setup and print options Working with rows, columns and cells Cut, Copy and Paste Introduction to functions and formulas Formatting in Excel, including formatting cells and numbers Creating charts and graphs Sorting and Filtering Introduction to PivotTables Logical and lookup formulas - the basics PowerPoint 2019 How to navigate around PowerPoint Presentation dos and don'ts Text and bullet edition options How to use graphics, images, objects and shapes Using SmartArt Working with Charts and Graphs How to utilize Master Slides and just how much time this could save you How to add audio and video to a presentation All about transitions between slides Animation, the animation pane and motion paths Setting your slideshow options Presentation preparation and delivery The backstage area of PowerPoint including printing a presentation Word 2019 How to get started with Word 2019 Word 2019 basics including navigation, editing and saving Character formatting in Word including Format Painter and AutoCorrect How to properly work with bullets and numbering in Microsoft Word All about formatting paragraphs and managing lists Working with Tables in Word including formatting, converting data and formulas Page appearance including page-breaks, watermarks and styles All about Sectioning a document Inserting graphics, pictures, shapes, icons and 3d models (new for 2019) How to work with envelopes and labels All about mail-merge and operating Word at scale How to create an Index or Contents page Reviewing and Printing in Word and Page Setup Protecting a Word document and basic macros in Word Microsoft Access Where to start in Microsoft Access and whether to use a template or not How to modify Access to suit your needs All about importing data and the datasheet view How tables work in Access and how to create relationships between them Creating forms and sub-forms that feed data into your tables How to run queries in Access Setting up validations and calculations using expressions in Access Printing from Access To start to use macros and Modal Dialog The basics of the Access web app Exporting and reporting in Access ***Exercise and demo files included*** This bundle includes: 29+ hours of video tutorials 300+ individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more!

Are you returning to work after a break? Perhaps you have a job interview. Or maybe you just need to brush up on some basic skills to help in your day to day work. Here we give you a crash course of 60 minutes of the 5 most used Office applications. You will learn the basics of Excel, PowerPoint, Word, Outlook and OneNote. A full 5 hours of essential training. Select all topics or just the ones you need to brush upon. By the end of each 60 minutes you will have learned enough to know the basics of the application and be able to carry out day to day tasks efficiently and effectively.

Everyday, for most of the hours of your day, you work on your computer, trying to convert your thoughts and intentions into digital files. And if you are like most people, that means hand on your mouse, clicking on menus, moving a slow digital finger and pointing and clicking . You're building spreadsheets, formatting documents, building presentations. What if you could do you work in half the time, or do twice as much in the same amount of time it takes you today? This course will make you FASTER. You'll go through the major programs of Excel, Word and PowerPoint and learn the shortcut keystrokes that help you do your everyday, every minute activities at the speed you think them, not the speed you can point and click. You'll also learn some super powerful, but rarely discovered speed tips, like selecting visible cells only in a single click, or inserting a custom header format in a single action. Because this is not a course on specific features only useful in specific situations, but rather general tools to use across all situations, you can instantly apply what you learn in this course to the files and programs you are using today. So join the course and let's start getting faster at Microsoft Office today!

Master the Ins and Outs of Microsoft Office and Boost Your Office’s Productivity. Spreadsheets with Excel 2013 Documents with Word 2013 E-mail with Outlook 2013 Presentations with PowerPoint 2013 Databases with Access 2013 Print Publications with Publisher 2013 Make Your Office More Efficient with Microsoft’s Premier Office Management Software Whether you need to create a spreadsheet for data analysis, a database of customer contacts, or a brochure that outlines the strengths and appeal of your organization, Microsoft Office is the choice of many office professionals. Enjoy significant control over your calendar and communication with Outlook or create engaging presentations with PowerPoint. Many people are aware of the basics of what Office can do, but learning the more advanced capabilities of the programs in Office gives you greater flexibility and opportunities for creativity. Microsoft Office is designed to make accomplishing office tasks easier and more efficient. Contents and Overview The course is designed for individuals and office professionals who need to master the capabilities of the latest edition of Microsoft Office. Through over 71 hours of video lectures and 8 quizzes, you’ll learn everything you need to know to make your office run more efficiently with Office 2013. Excel 2013 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses. Excel 2013 Advanced: Use complex formulas and perform data analysis on your organization’s revenue and expense patterns. Word 2013: Create documents, embed videos, and set up for online collaboration for joint projects for school or work. Outlook 2013: Gain control of your inbox and avoid accumulating hundreds of unanswered emails. PowerPoint 2013: Make slick presentations for your next business meeting using animation, audio/video, and collaborative tools. Access 2013 For Beginners and Access 2013 Advanced: Become a master of data management, tracking customer information and buying patterns. Publisher 2013: Create professional looking print publications to communicate the strengths and purpose of your organization. When you complete this course, you’ll be well on your way to becoming a master at workplace efficiency with the tools available in Microsoft Office 2013. ** Updated June 2017. Course transcripts now available.

**This course includes practice exercises and LIFETIME access** Massive value bundle - 3 full courses in one! Learn Excel, PowerPoint and Word 2019 with Microsoft Office experts Simon Sez IT. This mega Microsoft Office bundle is perfect if you're looking to finally get to grips with Excel, PowerPoint and Word. Each course goes into depth on how to get the most from each program and will  help you become an intermediate user. What's included? Excel 2019 What's new in Excel 2019 Creating workbooks Entering text, numbers and working with dates Navigating workbooks Page setup and print options Working with rows, columns and cells Cut, Copy and Paste Introduction to functions and formulas Formatting in Excel, including formatting cells and numbers Creating charts and graphs Sorting and Filtering Introduction to PivotTables Logical and lookup formulas - the basics PowerPoint 2019 How to navigate around PowerPoint Presentation dos and don'ts Text and bullet edition options How to use graphics, images, objects and shapes Using SmartArt Working with Charts and Graphs How to utilize Master Slides and just how much time this could save you How to add audio and video to a presentation All about transitions between slides Animation, the animation pane and motion paths Setting your slideshow options Presentation preparation and delivery The backstage area of PowerPoint including printing a presentation Word 2019 How to get started with Word 2019 Word 2019 basics including navigation, editing and saving Character formatting in Word including Format Painter and AutoCorrect How to properly work with bullets and numbering in Microsoft Word All about formatting paragraphs and managing lists Working with Tables in Word including formatting, converting data and formulas Page appearance including page-breaks, watermarks and styles All about Sectioning a document Inserting graphics, pictures, shapes, icons and 3d models (new for 2019) How to work with envelopes and labels All about mail-merge and operating Word at scale How to create an Index or Contents page Reviewing and Printing in Word and Page Setup Protecting a Word document and basic macros in Word ***Exercise and demo files included*** This bundle includes: 21+ hours of video tutorials 250+ individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… “I've been familiar with this program for years, but am getting more comfortable and learning more than I could have imagined this early in the course.” - Aimee Hutcherson “I'm learning alot of new material that I had no idea existed. So yes , I'm very much liking this course. Will continue to practice all the new skills I've learned thus far." - Eralda Chung-Colon “I enjoy learning all of the new things in this course so far and I really appreciate how thorough the instructor is at explaining everything. Great Course!!" - Jennifer Lambert Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more!

Why to buy individual courses when this complete package will give you everything you need! Boost your career and stand out from others in crowd!! 1. Microsoft Word (Basic course) 2. Microsoft Word (Advanced course) 2. Microsoft Excel (Basic course) 4. Microsoft Excel (Advanced course) 3. Unlock Macros & VBA Programming course Microsoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course: Looking for an online Excel course to improve your skills and save time but don't know where to start? I have picked out the Excel Essential skills and packaged them in a structured course. I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects. Microsoft Word complete Package - Don't use just Word, learn tips and tricks with this course to be a smart user. This course includes basic level, intermediate level and advanced level of MS Word. Enroll now to go from beginning to Advanced user. At completion of this course you will have mastered the Microsoft Word. Microsoft Excel: By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to: Input Data and Navigate Large Spreadsheets Easily build dynamic tools & Excel dashboards to filter, display and analyze your data Apply Excel hacks to get your work done faster Be able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more) Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions Get Answers from your Data Organize, Clean and Manage Large Data Create Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines Import & transform data with tools like Get & Transform (Power Query) Manipulate dates, times, text, and arrays Reduce manual routine tasks to the click of button VBA programming & read, write own Macro to automate the tasks We will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn: Useful Excel shortcuts for data entry and navigation. Protect your Excel files and worksheets properly. To apply formatting correctly for cleaner and more professional reports. To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell. Add Comments & Notes to cells & how to print the same if needed. Add Data & time Stamps to your reports. Lookup/Reference Functions. Statistical Functions. Logic Functions. Text Functions. Date & Time Functions. The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more. Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.) Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data. What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets Use Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data. Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables. Import data from Text File. Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons. More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced. Microsoft Word: At completion of this course you will have mastered the most popular and sought after Microsoft Word tools and come away with confidence to complete many Word tasks with efficiency and grace. Below are just a few of the topics you will master: Creating Dynamic Microsoft Word Documents Effectively Formatting a Document with Styles Prepare Documents for Printing and Exporting Manage Large Documents Working with Page and Section Breaks Control Page Orientation Create and Manage Table Layouts Work with Tab Stops to Align Content Properly Insert Media and Images Perform Mail Merges to create Mailing Labels and Form Letters Manage Templates Protect Documents from Edits Track and Accept/Reject Changes to a Document Build Dynamic Table of Contents and much, much more... What differentiates this course from other Courses? Yes, there are many Microsoft Office Courses out there teaching you the important functions and features you need to master. BUT, do you get step-step-step learning with of Microsoft Word, Microsoft Excel with Quizzes, Exercises and VBA programming all in one course? So, what are you waiting for? Enroll Today and take the next step in mastering Excel, Word and VBA Programming. Boost your career and stand out from others in crowd . Go from Novice to Ninja in all this complete package of Microsoft Word, Microsoft Excel, Macros & VBA! Become a certified Excel, Word & VBA Ninja Today. The course comes with lifetime access. Buy now. Watch anytime.